Marsh Corporation Company Schedule of Cash Receipt For January through May Nov.DecJanFebMar Sales $175,000 $ 232,500 $ 263,500 $ 186,000 $ 217,000 Credit Sales 100% $175,000...

yflbkr

Main

Home >Homework Answsers >Business & Finance homework help >Accounting homework help

Marsh Corporation Company
Schedule of Cash Receipt
For January through May
	Nov.	Dec	Jan	Feb	Mar
Sales	$175,000	$ 232,500	$ 263,500	$ 186,000	$ 217,000
Credit Sales 100%	$175,000	$ 232,500	$ 263,500	$ 186,000	$ 217,000
Collections:
50% in current month		$ 87,500	$ 116,250	$ 131,750	$ 93,000
Collections:
50% of credit sales in 2 mos.			$ 87,500	$ 116,250	$ 131,750
Total Collections:			$ 203,750	$ 248,000	$ 224,750



Marsh Corporation Company
Monthly Cash Payments
For January through May
	Nov.	Dec	Jan	Feb	Mar
Sales	$175,000	$ 232,500	$ 263,500	$ 186,000	$ 217,000
Marterials		1,800,000	1,400,000	2,000,000	2,500,000
Payment for Materials			28000	84000	120000
Payment for labor (20 per 1,000)			28000	40000	50000
Payment for overhead (10 per 1,000)			28000	40000	50000
Selling and Administraive (20% sales)			$ 52,700	37,200	$ 43,400
Payment for taxes
Dividends paid
Total Cash Payment


Marsh Corporation
Forecasting with Seasonal Production
	Dec.	Jan	Feb	Mar	Apr	May
Projected unit sales	1,500,000	1,700,000	1,200,000	1,400,000	2,000,000	2,500,000
Desired ending Inventory (+)	2,900,000	2,600,000	3,400,000	4,500,000
Beginning Inventory (-)	2,600,000	2,900,000	2,600,000	3,400,000
Units to be produced	1,800,000	1,400,000	2,000,000	2,500,000


Marsh Corporation Company
		Monthly Cash Flow
	Jan.	Feb	Mar
Cash Receipts
Cash Payments
Net Cash Flow



Marsh Corporation Company
*Cash Budget*
	Jan.	Feb	Mar
Net Cash Flow
Beginning Cash Balance
Cumulative Cash Balance
Loans and (Repayments)
Cumulative Loans
Marketable Securities
Cumulative Marketable Securities
Ending Cash Balance


Marsh Corporation
*Pro Forma Income Statement*
	Jan.	Feb	Mar	Total
Sales
Cost of Goods Sold
Gross Profit
Selling and Admin. Expense
Interest Expense
Net Profit Before Tax
Taxes
Net Profit After Tax
Less: Common Dividends
Increase in Retained Earnings

10 years ago
999999.99

Report issue

Answer(0)

Bids(0)

other Questions(10)